Getting Started with Microsoft Power BI Training
Updated: 2023-08-30 05:00:00
Resources for learning and becoming more proficient with Power BI including articles, downloads, and courses.- Resources for learning and becoming more proficient with Power BI including articles, downloads, and courses.
Prepare for the AZ-900 Microsoft Azure Fundamentals Certification
Updated: 2023-08-29 05:00:00
This article covers how to prepare for the Microsoft exam AZ-900: Microsoft Azure Fundamentals along with links to books, study guides, exam topics and more.Microsoft Fabric: Loading On-Premises and External Data
Updated: 2023-08-28 17:00:57
Loading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. However, during this preview stage, Microsoft Fabric brings many surprises (and, should I say, deceptions?) in this area. This blog may explain a lot, but I’m not bringing conclusions, but lot of questions. It will be a pleasure …
The post Microsoft Fabric: Loading On-Premises and External Data appeared first on Simple Talk.
Impact of Offline SQL Server Index Rebuilds
Updated: 2023-08-28 05:00:00
This article explains what happens to SQL Server queries when you rebuild an index offline and the differences for online rebuilds and index reorgs.A Beginners Guide to MySQL Replication Part 5: Group Replication
Updated: 2023-08-28 00:00:29
MySQL Group replication is a remarkable feature introduced in MySQL 5.7 as a plugin. This technology allows you to create a reliable group of database servers. One of the most important features of MySQL’s group replication is that it allows these servers to store redundant data. This allows the database state to be replicated across …
The post A Beginners Guide to MySQL Replication Part 5: Group Replication appeared first on Simple Talk.
Yet Another Reason to Not Use sp_ in your SQL Server Object Names
Updated: 2023-08-25 21:41:42In 2012, Aaron Bertrand said most everything I knew (and a bit more) about the issues with using the sp_ prefix. Procedures prefixed with sp_ have special powers when placed in the the master database in that it can be executed anywhere on the server after that. Nothing much has change in those suggestions. It … The post Yet Another Reason to Not Use sp_ in your SQL Server Object Names appeared first on Simple Talk.Learning DAX in Excel: A Step-by-Step Tutorial for Beginners
Updated: 2023-08-24 05:00:00
In this tutorial, learn how to use DAX to build Excel functions to build efficient data models for data analysis.Query Multiple Azure SQL Databases and Save Results Centrally
Updated: 2023-08-23 05:00:00
In this article, we look at how to query multiple Azure SQL Databases and store all the results in a centralized location.AI-900: Microsoft Azure AI Fundamentals Certification Exam Tips and Tricks
Updated: 2023-08-22 05:00:00If you are thinking about taking exam AI-900: Microsoft Azure AI Fundamentals this article includes several resources to help you pass this exam.SQL Server Execution Plan Issues when using TOP Clause and Various Parameters
Updated: 2023-08-22 05:00:00
In this article, we look at how SQL Server may not always pick the best execution plan based on different parameter values that are used and how this can be solved with proper indexes.Fabric Lakehouse: Convert to Table feature and Workspace Level Spark Configuration
Updated: 2023-08-21 17:00:05
I have been working as a no-code data engineer: Focused on Data Factory ETL and visual tools. In fact, I prefer to use visual resources when possible. On my first contact with Fabric Lakehouse I discovered to convert Files into Tables I need to use a notebook. I was waiting a lot of time for …
The post Fabric Lakehouse: Convert to Table feature and Workspace Level Spark Configuration appeared first on Simple Talk.
Generate Test Data Sets for Testing SQL Server Database Applications
Updated: 2023-08-21 05:00:00
In this article, we look at different approaches for generating test data sets for testing database applications.Learning PostgreSQL With Grant: Introducing VACUUM
Updated: 2023-08-21 00:01:11While there are many features within PostgreSQL that are really similar to those within SQL Server, there are some that are unique. One of these unique features is called VACUUM. In my head, I compare this with the tempdb in SQL Server. Not because they act in any way the same or serve similar purposes. … The post Learning PostgreSQL With Grant: Introducing VACUUM appeared first on Simple Talk.GitHub Copilot Examples to Create SQL Server Indexes and Tune Queries
Updated: 2023-08-18 05:00:00
In this article, we test use cases for Copilot to create SQL Server indexes, tune queries, compare queries to determine which will perform better, and more.Setting up Drill Through in the New Power BI Report User Interface
Updated: 2023-08-17 04:56:30
In this article, learn how to implement drill-through in Power BI reports using the new user interface.How much has data technology changed over the years?
Updated: 2023-08-16 16:08:30The simple answer to this question is “a lot.” The funny part, however, is that everyone who reads that question will have similar but very different thoughts on those changes. Unless your job (or hobby) is keeping up with the current trends in technology, the biggest thing that affects our perception is how we have … The post How much has data technology changed over the years? appeared first on Simple Talk.Improve SQL Server Query Performance when Clustered Index Seek Operation is Slow
Updated: 2023-08-16 05:00:00
In this article, we look at how SQL Server indexes may be efficient for some queries but not others and steps to take to improve performance.SQL Declare Variable to Define and Use Variables in SQL Server code
Updated: 2023-08-16 05:00:00
Learn how to define and use variables in SQL Server code with these many different code examples.Power BI Datamart Low-Code and No-Code Functionality to Streamline Reporting
Updated: 2023-08-15 05:00:00
Learn about Power BI Datamarts a LowCode/NoCode interface that integrates dataflows, data warehousing and shared Power BI datasets to centralize and streamline reporting.How to Build a Custom Tornado Chart in Power BI Desktop
Updated: 2023-08-15 05:00:00
Learn about tornado charts and how to build a tornado chart in Power BI.Discover the Microsoft Fabric Data Wrangler
Updated: 2023-08-14 17:00:48
The Data Wrangler is as interesting as hidden inside Microsoft Fabric. It’s not easy to find and activate it, but it is worth the trouble. Before digging into the Data Wrangler, let’s analyze the data features in the query environment. Data Features in Query Environment The new query environment, which allow us to make data …
The post Discover the Microsoft Fabric Data Wrangler appeared first on Simple Talk.
Unraveling the Tuple Mover for SQL Server Columnstore Indexes
Updated: 2023-08-14 05:00:00
Learn about the tuple mover in SQL Server, what it is, and how it works to maintain SQL Server columnstore indexes in the background.What are Capacities in Microsoft Fabric?
Updated: 2023-08-14 05:00:00
In this article, we look at what capacities are available for Microsoft Fabric and a breakdown of the cost structure for these services.Use T-SQL to Perform Statistical Calculations on SQL Server Data
Updated: 2023-08-10 05:00:00
In this article, we look at how to use T-SQL to perform statistical calculations on data within SQL Server tables, specifically using stock data for the examples.SQL Server vs Oracle: File Watcher Process
Updated: 2023-08-10 05:00:00
In this article, we look at how to setup a file watcher process for SQL Server or Oracle to alert you when new files arrive in a folder.Learn about Data Warehousing for Analytical Needs
Updated: 2023-08-09 05:00:00
Learn about data warehousing and the differences between a data warehouse and a relational database to meet your analytical needs.Behavior of Scoped Transactions in Snowflake
Updated: 2023-08-09 05:00:00
In this article, we illustrate the behavior of scoped transactions when using Snowflake along with examples.Getting Started with Visualizing Real-Time Data with Python Bokeh
Updated: 2023-08-08 05:00:00
Discover how to utilize Python to visualize streaming data in real-time on your browser with Bokeh.Append Columns to SQL Server Table and Add Data to the Table
Updated: 2023-08-08 05:00:00
In this article, learn how to append columns to an existing SQL Server table as well as how to append data to a SQL Server table.SQL Logical Operators ALL, AND, ANY, BETWEEN, EXISTS, IN, LIKE, NOT, OR, SOME
Updated: 2023-08-07 05:00:00
Learn to use logical operators when writing SQL code such as ALL, AND, ANY, BETWEEN, EXISTS, IN, LIKE, NOT, OR, and SOME.Artificial Intelligence Features in Power BI for Report Development - Part 2
Updated: 2023-08-04 05:00:00
This article continues looking at AI capabilities in Power BI and how these can assist you in report development.